﻿CREATE PROCEDURE [acms].[Topic_GetAllByPostIdAndTopicGroupPath]
	@PostId int,
	@TopicGroupPath varchar(50)
AS
	SELECT a.*
	FROM Topic_View a
		inner join PostTopic_View b on a.Id = b.TopicId
	WHERE b.PostId = @PostId
		and TopicGroupPath = @TopicGroupPath
	ORDER BY Sequence
RETURN 0;